// MySQL test

select p.product_name, s.year, s.price from product p, sales s where p.product_id = s.product_id;


# Write your MySQL query statement below

# select w2.id
# from Weather w1, Weather w2
# where datediff(w2.recordDate, w1.recordDate) = 1 and w2.Temperature > w1.Temperature

select w2.id from weather w1, weather w2 
where datediff(w2.recordDate, w1.recordDate) = 1 and w2.Temperature > w1.Temperature;


